﻿CREATE TABLE [dbo].[TaskNotifying] (
    [Id]                         INT      IDENTITY (1, 1) NOT NULL,
    [IsDeleted]                  BIT      NOT NULL,
    [CreatedDate]                DATETIME NOT NULL,
    [ModifiedDate]               DATETIME NOT NULL,
    [TaskId]                     INT      NOT NULL,
    [NotifyingWhenStatusChanged] BIT      NOT NULL,
    [NotifyingPeriodically]      BIT      NOT NULL,
    [NotifyingFrequency]         INT      NOT NULL,
    [NotifyingDuration]          INT      NULL,
    [NotifyingStartTime]         DATETIME NULL,
    [NotifyingByEmail]           BIT      NOT NULL,
    [NotifyingByEmailTeamId]     INT      NULL,
    [NotifyingBySMS]             BIT      NOT NULL,
    [NotifyingBySMSTeamId]       INT      NULL
);

